Using Weekly Profit Projections

1. At the Year field, enter the fiscal year or press Enter to accept the system default of the current fiscal year.

2. At the Week Ending Date field, enter the week ending date or press Enter to accept the system default.

Note: The date entered must be the last day of a week as defined in the Company Week Ends setting in Ledger Options. If the date is entered for another day, you will be prompted to enter a valid week-ending date.

Note: The actual sales for the week(s) entered are compared to the total of the weekly sales 1-5 previously reported and updated. If the total of the weekly numbers (weeks 1-5) do not match the month-to-date sales numbers, the variance will be displayed. The user will be asked to continue. A variance will be generated if there were uncosted records from the prior weeks that costed through the system during the week the report was run for; a variance will also be generated if invoices or credit invoices with last or prior weeks dates were processed this week. Selecting "no" will cause the user to exit the weekly profit projection report; selecting "yes" will cause the variance to post to the current week’s numbers.

3a. The first section displays the following information about sales. The sales information is taken from posted customer invoices whose invoice dates fall within the date ranges reported.

Note: The report only includes sales and gross profit for orders that are both posted and costed.

Sales and Sales Adjustments

Current Week and Month-to-Date: By sales rep, broker, sales category, and category manager/buyer

• Sales – Total sales by sales rep, broker, sales category, category manager/buyer
• GP % – The gross profit percent by sales rep, broker, sales category, category manager/buyer, and gross margin adjustment percent
• GP $ – The gross profit dollars by sales rep, broker, sales category, category manager/buyer, and gross margin adjustment dollars
• Adjustment – The name, current week sales dollars, current week gross profit dollars, month-to-date sales dollars, and gross profit dollar amount adjustments entered to adjust the total sales for unrecorded transactions.

3b. Next the sum of any inventory cost adjustments and any additional adjustments are reported for the current week and month-to date.

Gross Margin Adjustments:

• Inventory Type Cost Adjustment by Inventory Adjustment type –The adjustment amount as percentage of gross profit and dollar amount of adjustment.
• Gross Margin Adjustments – The name, current week, and month-to-date dollar adjustment entered.

3c. Finally, budget, historical, and actual operating expenses are displayed. The operating expense information is taken from transactions posted to the ledger with the classification taken from the account definition. Historical expenses are taken as an average of the last six weeks actual in saved Weekly Profit Projections.

Operating Expenses

Current Week: Plant, Selling, Selling Other and G&A Expenses as defined in theaccount field for each category below and a user entered actual operating expense adjustment.

• Budget – Budgeted expenses by account type
• History – The average of posted expenses by account type for the last 6 weeks, not inclusive of the current week
• Actual – Actual (or projected) expenses by account type.

Month To Date:

• Actual total amounts entered month-to-date
• Operating expense adjustment month-to-date.

4. Command options appear:

• Change – Select Change to enter an adjustment to sales, gross margin, or operating expenses. Use the arrow keys to select a line to modify. In the Sales and Gross Marin sections, only the adjustment lines maybe be modified; however, any of the lines may be modified in the Operating Expenses sections.
• For sales adjustments – Enter the description for the adjustment, the sales dollars, and cost for the week and override the previously entered month-to-date sales dollar and cost adjustments.
• For gross margin adjustments – Enter the weekly and month-to-date description and dollar amount adjustment.
• For operating expense adjustments – Enter the weekly and month-to-date adjustment name and dollar amount.
• Recalc – Select Recalc to recalculate the variance. The variance is based on current information and resents/recalculates the weekly adjustments to zero

Note: This option only appears if the report has been saved previously. .

• Print(X) – Select Print to print the report.
• Next Pg/Prior Pg – Select Next Pg/Prior Pg to move forward one page or back one page.

5. Press Enter to confirm your selection. If the line is an adjustment line, you may type in text to describe the type of adjustment. Press Enter to move onto the Current Week Gross Profit Dollars column in the Sales and Gross Margin sections, or the Actual column in the Operating Expenses section. Press Enter to modify the Month-to-Date column.

6. Select Update to save your changes.

Important: Your changes will not be saved unless you select Update.

Security Required : Ledger - Ledger Reports